Excel 2019 - Formulas and Referencing, Working with Functions and Named Ranges
      This course is part of the MOS exam 77-727 range that will teach you the essential skills to successfully pass the Microsoft Office Specialist (MOS) certification exam. In this course you will learn about Formulas and Referencing. You will also learn about Working with Functions and Named Ranges.      
      Formulas and Referencing      
      Upon successful completion you will be able to:

1. Identify Formula Operators;
2. Understand Operator Precedence;
3. Over-ride Operator Precedence;
4. Enter Formulas;
5. Copy Formulas;
6. Use AutoFill;
7. Update Formula Results;
8. Use Absolute References;
9. Apply Percentage Values.
      
      Working with Functions      
      Upon successful completion you will be able to:

1. Identify Function Components;
2. Enter Functions;
3. AutoSum Numbers;
4. Use the AutoSum List;
5. Use the ROUND Function;
6. Apply the IF Function.		      
      Named Ranges      
      Upon successful completion you will be able to:

1. Name Cells;
2. Name Cell Ranges;
3. Add to and Edit Named Ranges;
4. Change Range Names;
5. Use Go To;
6. Navigate using Cell Names;
7. Use Names in Formulas;
8. Display Cell Formulas;
9. Delete Named Ranges.

      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2019 - Formulas and Referencing, Working with Functions and Named Ranges :
Program Training Courses - Microsoft Excel 2019 :
Office Suite Training Courses - Microsoft Office 2019 / Office 365 :
© 2020 Online Training Masters